package jwdt.xadmin.finace.action;

import jwdt.common.action.BaseAction;

public class FinaceAction extends BaseAction {
	String url = "/xadmin/finace/";
	//
	String sql_selAcc = "select id as 'key', name as 'value' from ha_account where zt='1' order by px";
	String sql_selUser = "select id as 'key', name as 'value' from ha_user where zt='1' order by px";
	String sql_selType = "SELECT a.mxdm AS 'key', a.mxmc AS 'value' FROM ha_flmx a,ha_fl b WHERE a.fldm=b.fldm AND b.zt=1 ORDER BY a.px";
	//
	String sql_inAcc = "SELECT SUM(a.logprice) FROM ha_log a, ha_flmx b WHERE a.type=b.MXDM AND b.FLDM='income' AND account=?";
	String sql_outAcc = "SELECT SUM(a.logprice) FROM ha_log a, ha_flmx b WHERE a.type=b.MXDM AND b.FLDM!='income' AND account=?";
	//
	String sql_mxqx = "SELECT fldm AS 'key', flmc AS 'value' FROM ha_fl WHERE fldm='xsfw'";
	String sql_fzmc = "SELECT mxdm AS 'key', mxmc AS 'value' FROM ha_flmx WHERE fldm='fzmc'";
	//
	String sql_sumUser = "SELECT SUM(a.logprice) FROM ha_log a, ha_flmx b WHERE a.type=b.MXDM AND b.FLDM!='income' AND SUBSTRING(logtime, 1, 7)=? AND user=?";

}
